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.
N4951YH & B Aeronautics LLC · Miamisburg, OHN4952EHess Michael D · Wasilla, AKN4952GHighland Rim Aviation LLC · Springfield, TNN4952LWalters Larry C · Wasilla, AKN4952SPrecision Delta Corp · Ruleville, MSN4952TKeith Investments LLC · Verona, MSN4953AOlson Andrew P · Garfield, WAN4953EInland Fisheries And Wildlife · Augusta, MEN4953FQuinney William B · Kill Devil Hills, NCN4953GMcfly LLC · Casper, WYN4953JLent Kevin C · Glenwood, MNN4953LSale Reported · Harrells, NCSale reportedN4953VMccreery Aviation Co Inc · Mcallen, TXN4954DTracy Scott J · Santa Barbara, CAFirst renewal noticeN4954FGq Aviation LLC · Cherry Hill, NJN4954GKris Noone Air LLC · Wilmington, DEN4954LSavoie John P · Jal, NMN4955DBerman David M · Charlotte, NCN4955LDakan John M · Hemet, CAN4955PJuber Glenn E · Coconut Creek, FLN4955YLancaster Bryant F Jr · Troutman, NCN4956DSorbi Aviation Inc · El Cajon, CAN4956MMurray Timothy · Orlando, FLN4956NCosta Luiz A · Fort Myers, FLN4956VRegistered aircraftN4957DCummings Roy E · Fort Scott, KSN4957EKuckkahn Dale P · Lake Tomahawk, WIN4957FBravo Hotel LLC · Lewes, DEN4957LButler Cole A · Snowflake, AZN4957NRegistered aircraftN4957ZGuinasso Kimberly Marsh · Reno, NVN4958DHarmon Jon E · Turner, MTN4958FJuoni Joshua Charles · Oklahoma City, OKN4958JWinfrey Justin R · San Francisco, CAN4958LOgren James A · De Smet, SDN4958QSnider Scott E DBA · Turner, MTN4958VFrank John M Jr · Alexandria, VAN4959CDoll House Properties Inc · Chesapeake, VAN4959DEdwards Stephen L Trustee · Wasilla, AKN4959JTaylor James O · Marengo, ILN4959LFly Cht LLC · Chillicothe, MON4959SStrickland Luther Jearl · San Luis Obispo, CAN4959VCutlass Cruisers Inc · Howard Lake, MNN4959WSteverson Jill T · Newhebron, MSN495ABRayburn Jason A · Gibbon, NEN495ACRegistration Pending · Honolulu, HIRegistration pendingN495AUCohen Aircraft Leasing & Sales LLC · Dunwoody, GAN495BFFlood Bryan P · Minneapolis, MNN495CSmith David W · Milaca, MNN495CDJl Aviation LLC · Crestwood, KY
Back to AD 2007-04-19 R1