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.
N34985Long Sean L · Claremore, OKN34987Edgington Ray H · Sioux City, IAN34989Johnson Edward A · Ukiah, CAN3498FHole In The Sky Aviation LLC · Dallas, TXN3498NBedard Timothy S · Pittsburgh, PAN3498SEnz Vineyards Inc · Hollister, CAN3498TSky View Aviation LLC · Longwood, FLN3498UVintage Flyers LLC · Easton, PAN3498WKanz Robin Lea · Woodway, TXN3498XBackes Celso Jr · Pike Road, ALN34990Hark Ventures LLC · Tyler, TXN34991Hite Adam L · Farmington, NMN34995Huckins George J Jr · Live Oak, TXN34996Mcada Bernie · Lake Jackson, TXN34997Jumba John T · Munhall, PAN3499PTinny Twister Aviation LLC · Fort Myers, FLN3499SSky'S Mooney LLC · Missoula, MTN3499WAviator Solutions LLC · Oregonia, OHN3499ZRedmond Perry · Fairfield, NDN349AMEdwards Jackie W · Mooresville, NCN349BGBowling Green Flight Center LLC · Bowling Green, OHN349CNaqua LLC · Commerce Township, MIN349CEBroussard Blake A · Youngsville, LAN349CWTyson Geoffrey · Vancouver, WAN349DProfessional Training Aircraft LLC · Wilmington, DEN349DMRitter John A · Yorktown, VAN349EEConklin Ryan T · Camp Verde, AZN349ERWatkins Noble Marvin II · Port Saint Lucie, FLN349JMMortland Joseph A · Weymouth, MAN349JPCummings Danny L · Mcminnville, TNN349MNewhall Bud · Galt, CAN349MKNorth Star Aviation · Mankato, MNN349NDUnd Aerospace Foundation · Grand Forks, NDN349RAPratt Stephen M · Waxhaw, NCN349RFPhase 2 Ventures LLC · Seattle, WAN349RPMiranda Gary R · Vancouver, WAN349RVJs Aircraft Group LLC · Lewes, DEN349SBSkyfusion II LLC · Atlanta, GAN349SPWard Michael Allen · Quinlan, TXN349TWPilot Enterprises LLC · Norfolk, VAN349YVam Aviation LLC · Edmond, OKN34ADPremiere Aviation Inc · Concord, CAN34AFHangar 6 Aviation LLC · Destin, FLN34AJBiplane LLC · Bellingham, WAN34ANScala Peter M · Port Orange, FLN34AQZimmerman Steven W · Olathe, KSN34ARRobitaille Marc · East Bernard, TXN34ATField Kent · Santa Barbara, CAN34AUAirtime Ventures II LLC · Springfield, MON34AWValiair Lc Trustee · Casper, WY
Back to AD 2007-04-19 R1