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.
N3585WRodriquez Nat III · Odessa, TXN3585YSeemann Brian N · Lake Havasu City, AZN35868Spence Flight Service LLC · Enterprise, ORN3586FRegistration Pending · Phoenix, AZRegistration pendingN35877Turbine Conversions Ltd · Nunica, MIN3587FStout Colt W · Bosque Farms, NMN3587LVanatta J Dennis · Faribault, MNN3587QBerger Donald D · Ilwaco, WAN3587XFlynn Sean C · Torrance, CAN35883Sasquatch Alaska Adventure Co LLC · Fritz Creek, AKN35889Torgerson Management Inc · Turtle Lake, WIN3588PLewis' Flying & Maintenance Svc Inc · Morse, LAN3588UBattles Danny C · Burns Flat, OKN3589Sale Reported · Lonoke, ARSale reported, pending cancellationN3589FInmon Glen A · Pontotoc, MSN3589KClark Joseph D · Kilgore, TXN3589PNewsom Bearden And Cobb Inc DBA · Lubbock, TXN3589QHalfpap Rodney J · Quincy, ILN3589WCfi Aero LLC · Riverside, CAN3589YHmb Aviation LLC · St George, UTN358ALlewellyn Development LLC · Charlotte, NCN358BWard Mike · Carnesville, GAN358BGBowling Green Flight Center LLC · Bowling Green, OHN358BHKelley Zachary · Anchorage, AKN358BTRorabaugh Kenneth P · Sunrise, FLN358CAFreeman Braxton L · West Lebanon, NHN358CBHurn Farm Enterprises LLC · Grand Beach, MIN358CDOptimal Aircraft Management Mi LLC · Sanford, MIN358CFApm Leasing LLC · Casper, WYN358CMEathcirc 08 LLC · Tucson, AZN358CPCivil Air Patrol · Maxwell Afb, ALN358DGSky Equipment LLC · Salem, WIN358GAtp Taa LLC · Wilmington, DEN358JCDuran Peter F · Mesa, AZN358MMatuska Douglas G · Kent, WAN358MERibelin Holdings LLC · Yacolt, WAN358MKNorth Star Aviation · Mankato, MNN358QO'Quinn Shannon L · Ridgeland, SCN358RMMrm Phoenix Ltd · Cape Girardeau, MON358RVDerby Kevin R · Clearwater, FLN358RWHawley Elizabeth B · Wichita Falls, TXN358SBolla Bruce B · San Francisco, CAN358SANelson Robert M Jr · Plano, TXN358SPIscovich Angel L · Santa Barbara, CAN358TBSlezak David · Davison, MIN358TCEclipse Air Works LLC · Harker Heights, TXN358TFAir Fleet Holdings LLC · Missoula, MTN358TWTubreaux Aviation Services LLC · Shreveport, LAN358VAChapman James H · Mebane, NCN358WGenco Holdings LLC Series A · Corpus Christi, TX
Back to AD 2007-04-19 R1