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.
N39PVLeaving On Tulsa Time LLC · Tulsa, OKN39RFHughes Todd R · Euless, TXN39RHOlympic View Aircraft LLC · University Place, WAN39RLAdams Nathan M · Edgewater, FLN39SDMbm Leasing LLC · Jacksonville, NCN39SJArrigo Johnathan T · Mill Spring, NCN39SKJustman Robert A · Cotati, CAN39TBAlibi Flying Club · Bakersfield, CAN39TCPutnam Larry Paul · Tucson, AZN39TFFountain Timothy E · Miami Beach, FLN39TKCold Water Aviation LLC · Wabasso, MNN39TPAnderson Robert K · Cleveland, TNN39TSMiller William L · Williamson, GAN39WBDorstewitz Robert D · Watervliet, MIN39WDWilliams Ryan P · Calera, OKN39WYGd Logistics LLC · Circle, MTN39XPMason Samuel · Santa Paula, CAN39YBWeaver Brian R · Crossville, TNN3AAJones Stephen C · Wadsworth, ILN3ACMaurer Christian N · Loveland, OHN3AGManaged Aviation Inc · The Villages, FLN3AKSantana Barry W · Wasilla, AKN3AMBeavers William W · Bear Creek, NCFirst renewal noticeN3AQSinnott-Simonis Lyle · Girdwood, AKN3ARMatejczyk Daniel E · West Hills, CAFirst renewal noticeN3BCBenedict Larry · Dexter, NMN3BDCopley Johnnie H · Minooka, ILN3BGHildreth James D · Kennedy, ALN3BNHansen Warren K · Bozeman, MTN3BRSouthern Aircraft Consultancy Inc Trustee · Casper, WYN3BW4rc LLC · Kenedy, TXN3BYJamora Daniel L · Victorville, CAN3CLWehner Kaitlyn M · Malone, WIN3CNCheck Six LLC · Champaign, ILN3CSStone Clifford F Jr · Corning, CAN3CYSchultz Daniel A · Tipp City, OHN3DCPurpose Flight Inc · Wilmington, DEN3DMRogueaero LLC · Post Falls, IDN3DNNodorft Daniel F · Orlando, FLN3DQCrescent Aviation LLC · Rllng Hls Est, CAFirst renewal noticeN3DTBighorn Flying Company LLC · Wood River, NEN3DWWhite Robert D Trustee · Colorado Springs, CON3DXMchugh Michael J Trustee · Hailey, IDN3DYRegistered aircraftN3DZXtreme Flying Club LLC · Gansevoort, NYN3EAEarle Aircraft Inc · Hastings, FLN3ECLindsey John T · Blue Earth, MNN3EHHoppe Nicholas J · Big Lake, AKN3ELTwo If Buy LLC · Nashua, NHN3EM3em LLC · Karnack, TX
Back to AD 2007-04-19 R1