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.
N52JPBrush Wesley A · Sparks, NVN52JQQuaid Jeffrey G · Paso Robles, CAN52JSSweeney Jack R · Parker, AZN52JVSl Leasing Group LLC · Atlanta, GAN52KBRisjan Randy D · Westfield, NYN52KDWhite Taylor D · Gainesville, GAN52KKVon Sternbert Nicholas Josef · Valencia, CAN52KSDawson-Townsend Timothy M · Hingham, MAFirst renewal noticeN52KWFreedom Aviation LLC · Alexander, ARN52LCHarris Bill J · Evergreen, CON52LGGroom Lincoln · Wadmalaw Island, SCN52LKTretter Nicholas · Holden, MAN52LLSlone Corwin Scott · Waller, TXN52LULetourneau University · Longview, TXN52LVAltair Aircraft LLC · Gainesville, FLN52LWN8138l LLC · Metairie, LAN52MBRoark Dale L · Cheyenne, OKN52MMHappy Sky LLC · Brooklyn, NYN52MRShealy Berry J · Augusta, GAN52NLMarauder Aviation LLC · Cheyenne, WYN52PAOctagon Corp · Lewes, DEN52PCDitsch Craig · Hondo, TXN52PDAviation Endeavors LLC · Houston, TXN52PGCrew And Mgt Svcs LLC · Union Lake, MIN52PHRouth Frank D · Marion, NCN52PJJensen Paul · Highland Village, TXN52PTQualitair LLC Trustee · MichelstadtN52QTFly Qts LLC · Oconomowoc, WIN52RARennenkampf Erik J · Columbia, MDN52RBHeights Multi Flight Management LLC · Monroeville, NJN52RMStone Patrick S Jr · Houston, TXN52RVByars Ernest C · Mooresboro, NCN52RWWorland Flying Club LLC · Worland, WYN52SBRedwood Oil Co Inc · Rohnert Park, CAN52SCTaylor Aaron Lee · Salado, TXN52SEPryor Jeff · Santa Barbara, CAN52SLWalker John D · Neosho, MOFirst renewal noticeN52SVGreen Diamond Holdings LLC · Dallas, TXN52SXBurrill Joel S · Merritt Island, FLN52TADowell Thomas · New Smyrna Beach, FLN52TFAs The Crow Flies LLC · Belmont, WIN52TMJorgensen Aviation Inc · Richfield, UTN52TSFox Whiskey Inc · Wilmington, DEN52TXSchad Thomas J · Gainesville, TXN52TZTurley Dale R · Poway, CAN52VBHarral Vaughn R · Prescott Valley, AZN52VVLaxo Sonya · Flower Mound, TXN52WEUnderwood Sean · Laurel, MDN52WLSpeare Aviation LLC · Summerfield, NCN52WWPacific Fleet Aviation LLC · Rochester, NY
Back to AD 2007-04-19 R1