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.
N3040FJump Tn LLC · Greeneville, TNN3040KLeading Edge Flight Academy LLC · Bend, ORN3040LLuft Inc · North Fort Myers, FLN3040PCedar Ridge Aviation LLC · Knox City, TXN3040QGrannetino Gerald F · West Chester, PAN3040XKamrath Jeffrey E · Forrest, ILN30413Eagle Sky Patrol Inc · Deadwood, SDN30417United States Of America Owner · Travis Afb, CAN30418Young Matthew B · Brighton, ILN3041AMiller Aircraft Services Inc · Crookston, MNN3041FRoffey Edward P Trustee · Grand Junction, CON3041KDodson International Parts Inc · Rantoul, KSFirst renewal noticeN3041WEstes Aviation LLC · Rapid City, SDN3041ZDunn Carrie B · Emporia, KSN30422Casey Michael B · Hemingford, NEN3042FTdc Aviation LLC · Scottsdale, AZN3042LMsl Holdings · Newbury Park, CAN3042NRunway Aircraft LLC · Sugar Land, TXN3042UAnderson Jacob P · Cleveland, TNN3042V3 Pandas LLC · Farmington, NMN3042XMariani Nut Co Inc · Winters, CAN30430Lazaro Ralph B · Pahrump, NVN30433Flying Hawks Inc · Palmyra, WIN30436Carson Charles E · North Vernon, INN30437Richards David N · Port Matilda, PAN3043CSelby Air LLC · Lorida, FLN3043QDerango Gregory J · Chitina, AKN3043ULindgren Bradley A · New Market, MNN3043YAll Aviation LLC · Wilmington, DEN3043ZMaria A Sklar Pa DBA Sklar Law Trustee · Fort Lauderdale, FLN30441Gillenwater Timothy J · Glasgow, KYN30443Songer Harvey · Beech Grove, ARN30446Gumz Terry J · Wailuku, HIN3044QParrow Ronald J · Hampton, CTN3044USkywest Leasing Inc · St George, UTN3044W625 Mike Tango LLC · Dickinson, TXN3044ZRoberts Marvin L · Calhoun, GAN30450Recker Timothy J · Aurora, IAN30452Midland Aircraft Sales & Service Inc · Marshalltown, IAN30453Lehman Land Management LLC · Vernon, TXN30458Spires William B · Minden, NVN3045AEssex Air LLC · Franklin Lakes, NJN3045CPadelford Leman W DBA · Taunton, MAN3045FFinley Eric · Ione, CAN3045GSlack Troy Trustee · New Concord, OHN3045KN3045k LLC · Belton, TXN3045QLong Randy B · Coleman, TXN3045TRegistered aircraftN3045YMassee Donald R · Riverside, CAN3045ZColson Douglas J · Emmitsburg, MD
Back to AD 2007-04-19 R1