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.
N490SPSky Training LLC · West Milford, NJN490TBowen Edmund L · Laguna Beach, CAN491Acadiana Fixed Wing Rotor Wing Inc · Carencro, LAN49105Carlyle Properties LLC · Columbia Falls, MTN4910AEverett Laurence B · Berkley, CAN4910DN4910d LLC · Delavan, WIN4910JGyure Ronald J · Fort Worth, TXN4910LPeake Alexander · Tacoma, WAN4910PWilkens Jacob James · Eagle River, AKN4910SMarden John E · Oakland, MEN4910UN4910u LLC · Cushing, OKN4911ASatra Jerry J · Sidney, MTN4911CGianni David C · Fairbanks, AKN4911ESchumacher Gregory Luther · Anchorage, AKN4911FFreed Michael L · Sylmar, CAN4911JDarter Lloyd R · Mountain Grove, MON4911LMccown Brian W · Janesville, CAN4911XLake Superior Helicopters LLC · Duluth, MNN4912EAdams Bruce M · Santa Fe, NMN4912FNab LLC · Wichita, KSN4912GHardee Christopher D · Smyrna, TNN4912SStevens Joel N · Monticello, ARN4913AOlson David J · Eugene, ORN4913DRosies Procurement LLC · Midlothian, TXN4913GLeading Edge Flight Academy LLC · Bend, ORN4913JPassmore Stephen B DBA · Lacrosse, WAN4913KRabbit Hole Solutions LLC · Helena, MTN4913LHaven Mark · Springfield, TNN4913UGarvey F Patrick · Churubusco, INN4914FCb N4914f LLC · Coventry, CTN4914LWallace Aviation Inc · Wallace, NEN4914QGudgel Daniel R · Lemoore, CAN4914UCaldwell Gregg P · Desert Hot Springs, CAFirst renewal noticeN4915CLang Carl R · Harper, TXN4915JFox Richard A · Boynton Beach, FLN4915LRoss Robert J · Landisville, PAN4915VPegasus Aviation LLC · Rogersville, MON4916APerkins Larry L DBA · Lake Elsinore, CAN4916DHoward Dan E · Hurricane, UTN4916FSkaggs Steven L · Winters, CAN4916GOngstad Anne Whitman · Robinson, NDN4916JRegistration Pending · Townsend, GARegistration pendingN4916LMl Monkeybar Inc · Mammoth Lakes, CAN4916PPiper Aviation Museum Foundation · Lock Haven, PAN4916TArithansa LLC · Big Bear City, CAN4917AAtp Aircraft 7 LLC · Wilmington, DEN4917DWright Tyler C · Wilmington, NCN4917GCarter Richard W · Bumpass, VAN4917JTendall Timothy A · Sudbury, MAN4917LBlankenbaker Myron K · Jacksonville Beach, FL
Back to AD 2007-04-19 R1