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.
N2786GAvery John W · Fergus Falls, MNFirst renewal noticeN2786XRegistered aircraftN2787AKnudson Erik · Chandler, AZN2787FWammen Gil V · Reva, SDN2787GGomez Bermudex Investments LLC · Lauderhill, FLN2787JLarson Jared E · Wasilla, AKN2787KWhirlwind Aviation Inc · Fisher, ARN2787QThorell Farms Inc · Loomis, NEN2787TBombero Aviation LLC · Childress, TXN2787WWhite Gary L · Ashland, KSN2788Tippit Larry Jack · Grand Prairie, TXFirst renewal noticeN2788FShryock Patrick D · King Salmon, AKN2788GCaldwell Gregg P · Desert Hot Springs, CAN2788QKahle Matthew N · Paw Paw, MIN2788THarnden Craig A · Lake City, FLN2789FHouck Joshua B · Wa Ct House, OHN2789QCenterline LLC · Yankton, SDN2789TLaycock Sean P · Plymouth, MIN2789WShort Robert N II · Lincoln, CAN278AMokulele Research Corp · Honolulu, HIN278AGEpic Aviation Inc · New Smyrna Beach, FLN278CA278ca LLC · Union Gap, WAN278CCUS Department Of The Interior · Boise, IDN278CDCirrus Aviators LLC · Elm Grove, WIN278CFInfinity Aviation LLC · Mandan, NDN278CMVarakantham Indra Sena Reddy · Allen, TXN278CRRittgers Timothy · Lapeer, MIN278DBCt42 LLC · New York, NYN278DSRelm Air LLC · Wilmington, DEN278FGRidgeline Assets LLC · Wilmington, DEN278FKKoelbl Aviation LLC · Whitesboro, TXN278GTankersley Aviation LLC · Sylacauga, ALN278HBEastman Douglas F · Eastlake, CON278HJJohnson Joel P · Duluth, MNN278JGThompson Barrett R · Smyrna, TNN278KERotor Technologies Inc · Nashua, NHN278MReid Stephen M · Gardner, KSN278MGGeorgia Aviation Authority · Eastman, GAN278MHSimms Hospitality Group LLC · El Segundo, CAN278NDRegistered aircraftN278PBP21000318 Inc Trustee · Wilmington, DEN278RHolliday Henry S · Poplarville, MSN278SHSmith Kenneth S Jr · Uvalde, TXN278SJOrr George Douglas · Hood River, ORN278SPSvetful Aviation LLC · Camden, SCN278ZKennerson Robert L · Palmer, AKN2790GBryan Roger J · Spearfish, SDN2790QArthur Lloyd T · Greenfield, INN2790WMoondogger LLC · Yakima, WAN27918Reneau Thomas E · Midland, TX
Back to AD 2007-04-19 R1