AD 2007-04-19 R1
Registered aircraft · 108,434
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N28969Silva Carlos A · Massapequa, NYN2896EFlight Club 502 Inc · Louisville, KYN2896FEvans Gene · Center, MON2896QWings Over Texas Holdings LLC · Denton, TXN2896RHuseman Adam · Clarinda, IAN28973Coffman Joseph Bryan · North Pole, AKN28976Kirby Benjamin · Colorado Springs, CON28978Cae Aviation Academy Phoenix LLC · Mesa, AZN28979Cae Aviation Academy Phoenix LLC · Mesa, AZN2897ASmiles Per Gallon LLC · Omaha, NEN2897FDeeck Mechanical Inc · Albemarle, NCN2897MInternational Air Services Inc Trustee · Carson City, NVN2897RGervase Russell G · Farmington, NMN2897UWwe LLC · Ridgway, CON2897WCasswell Paul H · Annapolis, MDN2897YRegistered aircraftN28981Walker William B · Spokane, WAN28983Radel Anne-Marie · West Hills, CAN28986Recreation Plus Inc · London, OHN2898TR P M Flying Club Inc · South Holland, ILN2898XOzment Dennis W · Palmyra, MON2898YKolling Aviation LLC · Spring Valley, MNN289915 By 5 Aircraft LLC · New Braunfels, TXN28993Fradkin Tyler Jacob · Redondo Beach, CAN28995Carlson Linda · Broomfield, CON28996H&A Aviation Lc · Hanover, VAN28998Clark Glenn W · Mary Esther, FLN2899DPye Houston W · Cloudcroft, NMN2899FWashburn Michael D · Farmington, UTN2899GYoungpeter David L · Spencerville, OHN2899TLessley Aviation LLC · Winona, MSN289BBPeters Alan M · Arcola, TXN289BLBlue Line Aviation LLC · Smithfield, NCN289CFWalker Dale Allan · Bakersfield, CAN289CLCripps Jason · Mcminnville, TNN289CRNiner Charlie Romeo LLC · Simpson, LAN289CSChow Rogers LLC · Fort Myers, FLN289DMTros Corp · Wilmington, DEN289DSMidwest Avtech Inc · Peru, ILN289GBKh Aviation LLC · Forest City, NCN289GRAerocomm LLC · Kalispell, MTN289HFLiegl Benjamin A · Fort Worth, TXN289HGGeorgia Aviation Authority · Eastman, GAN289HPLemon And Black LLC · Raleigh, NCN289JKFlightpath Aviation Services Inc · Brooksville, FLN289JMThibodeau Mark · East Falmouth, MAN289JSJet Air Inc · Iowa City, IAN289LASky Venture I Inc · Virginia Beach, VAN289MEWaseca Wings Inc · Owatonna, MNN289PRWalker James E · Fuquay Varina, NC
Back to AD 2007-04-19 R1