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.
N4505YGeneral Air Service LLC · Van Wert, OHN4506APennsylvania College Of Technology · Williamsport, PAN4506CIliamna Copper River Fly Fishing Lodge LLC · Livingston, MTN4506MBig Bend Community College · Moses Lake, WAN4506RCruz Roberto Jr · Douglasville, GAN4506SBaghs LLC · Fort Lauderdale, FLN4506TPettit Kenneth W · Madison, INN4506VRegistered aircraftN45077Qualitair LLC Owner Trustee · MichelstadtN4507FRodriguez Kenneth C · East Wenatchee, WAN4507JSkvara Stanley Henry Jr · Parma, OHN4507NGarnet Aviation LLC · Fort Worth, TXN4507QFrost Aviation Services Inc · Las Cruces, NMN4507RFly First LLC · West Memphis, ARN4507TLoma Aviation LLC · San Diego, CAN4507XVanny Ravy · Winchester, CAN4507YEmanuels Adam C · Selma, NCN4508ABonogofsky Thomas L · Bridger, MTN4508FStotz Jon · Rockford, MIN4508JWood Daniel W · Cottonwood Shores, TXN4508RMcmichael Timothy J · Rock Hill, SCN4508XWestchester Flying Club Inc · Purchase, NYN4509BTrompeter Mark S · Intl Falls, MNN4509HGolding Lee · Brookline, MON4509JHill Curtis E · Bancroft, IDN4509XPerformance Power Services Pc · Naperville, ILN4509YWolfrum John A · Two Rivers, AKN450AACentex Aero LLC Trustee · San Antonio, TXN450ASConroy Philip L · Colleyville, TXN450BASimmons Brian R · Heavener, OKN450CACoast Flight Training And Management Inc · Dallas, TXN450CDAlcyone Trust Corp Trustee · Wichita, KSN450CFZieger C Philip · Clearwater Beach, FLN450CSCbcb Aircraft LLC · Colfax, WAN450DHHewitt Rod · Federal Way, WAN450DLBay Larry · San Diego, CAN450EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN450FLMorriss Aviation LLC · Allen, TXN450JAHillsboro Aero Academy LLC · Hillsboro, ORN450JDJd Dakota Leasing LLC · Stuart, FLN450JRNowell Borders Lp · Edinburg, TXN450JTN450jt LLC · Colleyville, TXN450KSGreene Tammy G · Alpharetta, GAN450LHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN450MKNorth Star Aviation Inc · Mankato, MNN450PMStroede Scott E · King Salmon, AKN450RBurns Richard · Wasilla, AKN450RSMcpherson Norman B · Woodland Park, CON450THHk Air LLC · Byron, GAN450TXM And M Aviation Leasing LLC · Wilmington, DE
Back to AD 2007-04-19 R1